﻿<%@ Page Title="" Language="C#" MasterPageFile="~/common/Admin.master" AutoEventWireup="true" CodeFile="admin_applicant_list.aspx.cs" Inherits="admin_default" %>
<%------------------------ Jifen create 2013.06.05 -------------------------%>

<asp:Content ID="Content3" ContentPlaceHolderID="leftMenu" Runat="Server">
<ul>
     <li><a href="<%= Page.ResolveUrl("~/product/saving/admin/saving_apply.aspx")%>">
       Open Saving Account</a></li>
    <li><a href="<%= Page.ResolveUrl("~/product/card/admin/PendingApplication.aspx")%>">
        Debit Card Applicant List</a></li>
    <li><a href="<%= Page.ResolveUrl("~/product/insurance/admin/insurance_applicant_list.aspx")%>">
        Insurance Applicant List</a></li>
  
                   
    </ul>
</asp:Content>
<asp:Content ID="Content1" ContentPlaceHolderID="content" Runat="Server">
     
     <h1>List of new applicants</h1>
     <asp:GridView ID="gv_applicantList" runat="server" AutoGenerateColumns="False" 
         BackColor="White" BorderColor="#DEDFDE" BorderStyle="None" BorderWidth="1px" 
         CellPadding="4" DataSourceID="SqlDataSource_applicantList" ForeColor="Black" 
         GridLines="Vertical" 
         onselectedindexchanged="gv_applicantList_SelectedIndexChanged">
         <AlternatingRowStyle BackColor="White" />
         <Columns>
             <asp:BoundField DataField="Cust ID" HeaderText="Cust ID" ReadOnly="True" 
                 SortExpression="Cust ID" />
             <asp:BoundField DataField="Application ID" HeaderText="Application ID" 
                 ReadOnly="True" SortExpression="Application ID" />
             <asp:BoundField DataField="Type" HeaderText="Type" ReadOnly="True" 
                 SortExpression="Type" />
             <asp:BoundField DataField="Application Date" DataFormatString="{0:dd/MM/yyyy}" 
                 HeaderText="Application Date" ReadOnly="True" 
                 SortExpression="Application Date" />
             <asp:CommandField ButtonType="Button" SelectText="Details" 
                 ShowSelectButton="True" />
         </Columns>
         <FooterStyle BackColor="#CCCC99" />
         <HeaderStyle BackColor="#6B696B" Font-Bold="True" ForeColor="White" />
         <PagerStyle BackColor="#F7F7DE" ForeColor="Black" HorizontalAlign="Right" />
         <RowStyle BackColor="#F7F7DE" />
         <SelectedRowStyle BackColor="#CE5D5A" Font-Bold="True" ForeColor="White" />
         <SortedAscendingCellStyle BackColor="#FBFBF2" />
         <SortedAscendingHeaderStyle BackColor="#848384" />
         <SortedDescendingCellStyle BackColor="#EAEAD3" />
         <SortedDescendingHeaderStyle BackColor="#575357" />
     </asp:GridView>
     <asp:SqlDataSource ID="SqlDataSource_applicantList" runat="server" 
         ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
         SelectCommand="(SELECT custID [Cust ID],id  [Application ID], 'Debit Card'  as Type, applicationDate [Application Date] 
FROM ApplicationDebit WHERE status = 'PENDING')
UNION ALL 
(SELECT custID [Cust ID], applicationId [Application ID], CASE productType WHEN 'H' THEN 'Hospitalisation' WHEN 'A' THEN 'Accident' ELSE '' END  AS Type, applicationDate [Application Date]  FROM APPLICATION_INSURANCE WHERE (applicationStatus = 'PENDING'))">
     </asp:SqlDataSource>
     <p>&nbsp;</p>
     <p>&nbsp;</p>
     <p>&nbsp;</p>





     





</asp:Content>

